Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 3068040 |
| Missing cells | 69864605 |
| Missing cells (%) | 71.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 749.0 MiB |
| Average record size in memory | 256.0 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 25 |
| Unsupported | 1 |
| Categorical | 3 |
| Boolean | 2 |
step_mod has constant value "" | Constant |
delinq_disaster has constant value "" | Constant |
year_month is highly overall correlated with loan_age and 5 other fields | High correlation |
curr_upb is highly overall correlated with interest_bearing_upb | High correlation |
loan_age is highly overall correlated with year_month and 4 other fields | High correlation |
month_remaining_LM is highly overall correlated with year_month and 5 other fields | High correlation |
defect_settlement is highly overall correlated with year_month and 6 other fields | High correlation |
zero_bal_code is highly overall correlated with mod_flag | High correlation |
zero_bal_date is highly overall correlated with year_month and 5 other fields | High correlation |
curr_int is highly overall correlated with mod_cost and 1 other fields | High correlation |
ddlpi is highly overall correlated with year_month and 5 other fields | High correlation |
mi_rec is highly overall correlated with mod_flag and 1 other fields | High correlation |
net_sales is highly overall correlated with zero_bal_removal_upb and 3 other fields | High correlation |
non_mi_rec is highly overall correlated with mod_flag and 1 other fields | High correlation |
expenses is highly overall correlated with legal_costs and 7 other fields | High correlation |
legal_costs is highly overall correlated with expenses and 5 other fields | High correlation |
maint_costs is highly overall correlated with expenses and 3 other fields | High correlation |
tax_ins is highly overall correlated with expenses and 5 other fields | High correlation |
misc_expenses is highly overall correlated with expenses and 2 other fields | High correlation |
actual_loss is highly overall correlated with delinq_int and 2 other fields | High correlation |
mod_cost is highly overall correlated with defect_settlement and 6 other fields | High correlation |
eltv is highly overall correlated with month_remaining_LM | High correlation |
zero_bal_removal_upb is highly overall correlated with net_sales and 1 other fields | High correlation |
delinq_int is highly overall correlated with net_sales and 6 other fields | High correlation |
curr_month_mod_cost is highly overall correlated with curr_int and 1 other fields | High correlation |
interest_bearing_upb is highly overall correlated with curr_upb | High correlation |
mod_flag is highly overall correlated with defect_settlement and 15 other fields | High correlation |
deferred_payment_plan is highly overall correlated with mi_rec and 9 other fields | High correlation |
borrower_assistance is highly overall correlated with year_month and 1 other fields | High correlation |
mod_flag is highly imbalanced (85.2%) | Imbalance |
deferred_payment_plan is highly imbalanced (71.7%) | Imbalance |
defect_settlement has 3067897 (> 99.9%) missing values | Missing |
mod_flag has 3045608 (99.3%) missing values | Missing |
zero_bal_code has 3021495 (98.5%) missing values | Missing |
zero_bal_date has 3021495 (98.5%) missing values | Missing |
ddlpi has 3062559 (99.8%) missing values | Missing |
mi_rec has 3067497 (> 99.9%) missing values | Missing |
net_sales has 3067495 (> 99.9%) missing values | Missing |
non_mi_rec has 3067497 (> 99.9%) missing values | Missing |
expenses has 3067497 (> 99.9%) missing values | Missing |
legal_costs has 3067497 (> 99.9%) missing values | Missing |
maint_costs has 3067497 (> 99.9%) missing values | Missing |
tax_ins has 3067497 (> 99.9%) missing values | Missing |
misc_expenses has 3067497 (> 99.9%) missing values | Missing |
actual_loss has 3067495 (> 99.9%) missing values | Missing |
mod_cost has 3067580 (> 99.9%) missing values | Missing |
step_mod has 3067566 (> 99.9%) missing values | Missing |
deferred_payment_plan has 3063801 (99.9%) missing values | Missing |
eltv has 2581932 (84.2%) missing values | Missing |
zero_bal_removal_upb has 3021495 (98.5%) missing values | Missing |
delinq_int has 3067371 (> 99.9%) missing values | Missing |
delinq_disaster has 3064125 (99.9%) missing values | Missing |
borrower_assistance has 3062304 (99.8%) missing values | Missing |
curr_month_mod_cost has 3041908 (99.1%) missing values | Missing |
curr_deferred_upb is highly skewed (γ1 = 51.20668043) | Skewed |
curr_loan_delinq is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
curr_upb has 46545 (1.5%) zeros | Zeros |
loan_age has 45159 (1.5%) zeros | Zeros |
curr_deferred_upb has 3061632 (99.8%) zeros | Zeros |
interest_bearing_upb has 46545 (1.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-11-13 19:40:14.052823 |
|---|---|
| Analysis finished | 2023-11-13 19:46:33.208475 |
| Duration | 6 minutes and 19.16 seconds |
| Software version | ydata-profiling vv4.6.1 |
| Download configuration | config.json |
loan_id
Text
| Distinct | 49998 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.4 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 36816480 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 20 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | F09Q10000013 |
|---|---|
| 2nd row | F09Q10000013 |
| 3rd row | F09Q10000013 |
| 4th row | F09Q10000013 |
| 5th row | F09Q10000013 |
| Value | Count | Frequency (%) |
| f09q10193280 | 170 | < 0.1% |
| f09q10029420 | 170 | < 0.1% |
| f09q10125466 | 170 | < 0.1% |
| f09q10139325 | 170 | < 0.1% |
| f09q10036449 | 170 | < 0.1% |
| f09q10023250 | 170 | < 0.1% |
| f09q10043714 | 170 | < 0.1% |
| f09q10111127 | 170 | < 0.1% |
| f09q10111248 | 170 | < 0.1% |
| f09q10060099 | 170 | < 0.1% |
| Other values (49988) | 3066340 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 8260960 | |
| 9 | 4574870 | |
| F | 3068040 | 8.3% |
| Q | 3068040 | 8.3% |
| 2 | 2925726 | 7.9% |
| 3 | 2921976 | 7.9% |
| 1 | 2839724 | 7.7% |
| 4 | 2748838 | 7.5% |
| 5 | 1718646 | 4.7% |
| 6 | 1653645 | 4.5% |
| Other values (2) | 3036015 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 30680400 | |
| Uppercase Letter | 6136080 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 8260960 | |
| 9 | 4574870 | |
| 2 | 2925726 | 9.5% |
| 3 | 2921976 | 9.5% |
| 1 | 2839724 | 9.3% |
| 4 | 2748838 | 9.0% |
| 5 | 1718646 | 5.6% |
| 6 | 1653645 | 5.4% |
| 7 | 1526780 | 5.0% |
| 8 | 1509235 | 4.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 3068040 | |
| Q | 3068040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 30680400 | |
| Latin | 6136080 | 16.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 8260960 | |
| 9 | 4574870 | |
| 2 | 2925726 | 9.5% |
| 3 | 2921976 | 9.5% |
| 1 | 2839724 | 9.3% |
| 4 | 2748838 | 9.0% |
| 5 | 1718646 | 5.6% |
| 6 | 1653645 | 5.4% |
| 7 | 1526780 | 5.0% |
| 8 | 1509235 | 4.9% |
Latin
| Value | Count | Frequency (%) |
| F | 3068040 | |
| Q | 3068040 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 36816480 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 8260960 | |
| 9 | 4574870 | |
| F | 3068040 | 8.3% |
| Q | 3068040 | 8.3% |
| 2 | 2925726 | 7.9% |
| 3 | 2921976 | 7.9% |
| 1 | 2839724 | 7.7% |
| 4 | 2748838 | 7.5% |
| 5 | 1718646 | 4.7% |
| 6 | 1653645 | 4.5% |
| Other values (2) | 3036015 | 8.2% |
year_month
Real number (ℝ)
HIGH CORRELATION
| Distinct | 170 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201307.85 |
| Minimum | 200902 |
|---|---|
| Maximum | 202303 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 200902 |
|---|---|
| 5-th percentile | 200910 |
| Q1 | 201011 |
| median | 201206 |
| Q3 | 201506 |
| 95-th percentile | 202006 |
| Maximum | 202303 |
| Range | 1401 |
| Interquartile range (IQR) | 495 |
Descriptive statistics
| Standard deviation | 335.32616 |
|---|---|
| Coefficient of variation (CV) | 0.0016657381 |
| Kurtosis | 0.061064107 |
| Mean | 201307.85 |
| Median Absolute Deviation (MAD) | 200 |
| Skewness | 0.95596924 |
| Sum | 6.1762054 × 1011 |
| Variance | 112443.63 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 201003 | 48826 | 1.6% |
| 201002 | 48781 | 1.6% |
| 201004 | 48681 | 1.6% |
| 201005 | 48524 | 1.6% |
| 201001 | 48466 | 1.6% |
| 201006 | 48370 | 1.6% |
| 201007 | 48084 | 1.6% |
| 201008 | 47672 | 1.6% |
| 201009 | 46960 | 1.5% |
| 201010 | 46082 | 1.5% |
| Other values (160) | 2587594 |
| Value | Count | Frequency (%) |
| 200902 | 2897 | 0.1% |
| 200903 | 7369 | 0.2% |
| 200904 | 12037 | 0.4% |
| 200905 | 16059 | 0.5% |
| 200906 | 20189 | |
| 200907 | 24032 | |
| 200908 | 29415 | |
| 200909 | 33278 | |
| 200910 | 36670 | |
| 200911 | 40466 |
| Value | Count | Frequency (%) |
| 202303 | 3495 | |
| 202302 | 3509 | |
| 202301 | 3548 | |
| 202212 | 3586 | |
| 202211 | 3626 | |
| 202210 | 3668 | |
| 202209 | 3725 | |
| 202208 | 3779 | |
| 202207 | 3824 | |
| 202206 | 3869 |
curr_upb
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2239966 |
|---|---|
| Distinct (%) | 73.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 169449.64 |
| Minimum | 0 |
|---|---|
| Maximum | 790000 |
| Zeros | 46545 |
| Zeros (%) | 1.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36146.987 |
| Q1 | 90944.61 |
| median | 146153.61 |
| Q3 | 227857.28 |
| 95-th percentile | 383884.79 |
| Maximum | 790000 |
| Range | 790000 |
| Interquartile range (IQR) | 136912.67 |
Descriptive statistics
| Standard deviation | 107107.1 |
|---|---|
| Coefficient of variation (CV) | 0.63208807 |
| Kurtosis | 1.3500548 |
| Mean | 169449.64 |
| Median Absolute Deviation (MAD) | 64001.13 |
| Skewness | 1.0485595 |
| Sum | 5.1987827 × 1011 |
| Variance | 1.147193 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 46545 | 1.5% |
| 415000 | 3735 | 0.1% |
| 416000 | 3719 | 0.1% |
| 414000 | 3354 | 0.1% |
| 100000 | 2694 | 0.1% |
| 199000 | 2360 | 0.1% |
| 99000 | 2072 | 0.1% |
| 149000 | 2015 | 0.1% |
| 417000 | 1993 | 0.1% |
| 200000 | 1802 | 0.1% |
| Other values (2239956) | 2997751 |
| Value | Count | Frequency (%) |
| 0 | 46545 | |
| 0.01 | 1 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 3.14 | 1 | < 0.1% |
| 3.58 | 1 | < 0.1% |
| 5.18 | 1 | < 0.1% |
| 10.34 | 1 | < 0.1% |
| 11.99 | 1 | < 0.1% |
| 16.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 790000 | 1 | < 0.1% |
| 789000 | 1 | < 0.1% |
| 788000 | 2 | |
| 787000 | 2 | |
| 786000 | 3 | |
| 785000 | 1 | < 0.1% |
| 784000 | 2 | |
| 783000 | 1 | < 0.1% |
| 782959.35 | 1 | < 0.1% |
| 782000 | 1 | < 0.1% |
curr_loan_delinq
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 23.4 MiB |
loan_age
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 170 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.38163 |
| Minimum | 0 |
|---|---|
| Maximum | 169 |
| Zeros | 45159 |
| Zeros (%) | 1.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 15 |
| median | 34 |
| Q3 | 69 |
| 95-th percentile | 129 |
| Maximum | 169 |
| Range | 169 |
| Interquartile range (IQR) | 54 |
Descriptive statistics
| Standard deviation | 39.414968 |
|---|---|
| Coefficient of variation (CV) | 0.84979696 |
| Kurtosis | 0.1575117 |
| Mean | 46.38163 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 1.0035193 |
| Sum | 1.423007 × 108 |
| Variance | 1553.5397 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3 | 50224 | 1.6% |
| 2 | 50156 | 1.6% |
| 4 | 50134 | 1.6% |
| 5 | 49993 | 1.6% |
| 6 | 49846 | 1.6% |
| 7 | 49680 | 1.6% |
| 1 | 49491 | 1.6% |
| 8 | 49441 | 1.6% |
| 9 | 49149 | 1.6% |
| 10 | 48773 | 1.6% |
| Other values (160) | 2571153 |
| Value | Count | Frequency (%) |
| 0 | 45159 | |
| 1 | 49491 | |
| 2 | 50156 | |
| 3 | 50224 | |
| 4 | 50134 | |
| 5 | 49993 | |
| 6 | 49846 | |
| 7 | 49680 | |
| 8 | 49441 | |
| 9 | 49149 |
| Value | Count | Frequency (%) |
| 169 | 130 | < 0.1% |
| 168 | 326 | < 0.1% |
| 167 | 573 | < 0.1% |
| 166 | 789 | < 0.1% |
| 165 | 1076 | < 0.1% |
| 164 | 1411 | |
| 163 | 1790 | |
| 162 | 2071 | |
| 161 | 2358 | |
| 160 | 2724 |
month_remaining_LM
Real number (ℝ)
HIGH CORRELATION
| Distinct | 481 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 276.45411 |
| Minimum | 0 |
|---|---|
| Maximum | 480 |
| Zeros | 18 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 106 |
| Q1 | 230 |
| median | 309 |
| Q3 | 340 |
| 95-th percentile | 357 |
| Maximum | 480 |
| Range | 480 |
| Interquartile range (IQR) | 110 |
Descriptive statistics
| Standard deviation | 83.399474 |
|---|---|
| Coefficient of variation (CV) | 0.30167565 |
| Kurtosis | 0.14817279 |
| Mean | 276.45411 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | -1.0209931 |
| Sum | 8.4817228 × 108 |
| Variance | 6955.4723 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 357 | 37986 | 1.2% |
| 358 | 37976 | 1.2% |
| 356 | 37910 | 1.2% |
| 355 | 37799 | 1.2% |
| 354 | 37690 | 1.2% |
| 359 | 37598 | 1.2% |
| 353 | 37583 | 1.2% |
| 352 | 37409 | 1.2% |
| 351 | 37211 | 1.2% |
| 350 | 36932 | 1.2% |
| Other values (471) | 2691946 |
| Value | Count | Frequency (%) |
| 0 | 18 | < 0.1% |
| 1 | 36 | |
| 2 | 42 | |
| 3 | 47 | |
| 4 | 50 | |
| 5 | 53 | |
| 6 | 56 | |
| 7 | 57 | |
| 8 | 61 | |
| 9 | 65 |
| Value | Count | Frequency (%) |
| 480 | 32 | < 0.1% |
| 479 | 323 | |
| 478 | 396 | |
| 477 | 424 | |
| 476 | 430 | |
| 475 | 435 | |
| 474 | 436 | |
| 473 | 431 | |
| 472 | 430 | |
| 471 | 429 |
defect_settlement
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 46 |
|---|---|
| Distinct (%) | 32.2% |
| Missing | 3067897 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201173.33 |
| Minimum | 200911 |
|---|---|
| Maximum | 202005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 200911 |
|---|---|
| 5-th percentile | 201006.1 |
| Q1 | 201103 |
| median | 201106 |
| Q3 | 201205 |
| 95-th percentile | 201506.8 |
| Maximum | 202005 |
| Range | 1094 |
| Interquartile range (IQR) | 102 |
Descriptive statistics
| Standard deviation | 174.23748 |
|---|---|
| Coefficient of variation (CV) | 0.00086610629 |
| Kurtosis | 4.7658952 |
| Mean | 201173.33 |
| Median Absolute Deviation (MAD) | 97 |
| Skewness | 1.8910355 |
| Sum | 28767786 |
| Variance | 30358.701 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=46)
| Value | Count | Frequency (%) |
| 201106 | 31 | < 0.1% |
| 201205 | 18 | < 0.1% |
| 201104 | 9 | < 0.1% |
| 201009 | 6 | < 0.1% |
| 201011 | 5 | < 0.1% |
| 201012 | 5 | < 0.1% |
| 201101 | 4 | < 0.1% |
| 201102 | 4 | < 0.1% |
| 201204 | 3 | < 0.1% |
| 201109 | 3 | < 0.1% |
| Other values (36) | 55 | < 0.1% |
| (Missing) | 3067897 |
| Value | Count | Frequency (%) |
| 200911 | 3 | |
| 201002 | 2 | < 0.1% |
| 201004 | 1 | < 0.1% |
| 201005 | 1 | < 0.1% |
| 201006 | 1 | < 0.1% |
| 201007 | 2 | < 0.1% |
| 201008 | 1 | < 0.1% |
| 201009 | 6 | |
| 201010 | 1 | < 0.1% |
| 201011 | 5 |
| Value | Count | Frequency (%) |
| 202005 | 1 | |
| 201801 | 1 | |
| 201705 | 2 | |
| 201604 | 1 | |
| 201603 | 1 | |
| 201510 | 1 | |
| 201507 | 1 | |
| 201505 | 2 | |
| 201501 | 1 | |
| 201409 | 2 |
mod_flag
Categorical
HIGH CORRELATION IMBALANCE MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3045608 |
| Missing (%) | 99.3% |
| Memory size | 23.4 MiB |
| P | |
|---|---|
| Y | 474 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 22432 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Y |
|---|---|
| 2nd row | P |
| 3rd row | P |
| 4th row | P |
| 5th row | P |
Common Values
| Value | Count | Frequency (%) |
| P | 21958 | 0.7% |
| Y | 474 | < 0.1% |
| (Missing) | 3045608 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| p | 21958 | |
| y | 474 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 21958 | |
| Y | 474 | 2.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 22432 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 21958 | |
| Y | 474 | 2.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 22432 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 21958 | |
| Y | 474 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 22432 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 21958 | |
| Y | 474 | 2.1% |
zero_bal_code
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3021495 |
| Missing (%) | 98.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3692126 |
| Minimum | 1 |
|---|---|
| Maximum | 96 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 96 |
| Range | 95 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.1025621 |
|---|---|
| Coefficient of variation (CV) | 3.7266397 |
| Kurtosis | 325.17081 |
| Mean | 1.3692126 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.779564 |
| Sum | 63730 |
| Variance | 26.03614 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 1 | 45746 | 1.5% |
| 9 | 256 | < 0.1% |
| 3 | 134 | < 0.1% |
| 96 | 129 | < 0.1% |
| 16 | 124 | < 0.1% |
| 2 | 110 | < 0.1% |
| 15 | 46 | < 0.1% |
| (Missing) | 3021495 |
| Value | Count | Frequency (%) |
| 1 | 45746 | |
| 2 | 110 | < 0.1% |
| 3 | 134 | < 0.1% |
| 9 | 256 | < 0.1% |
| 15 | 46 | < 0.1% |
| 16 | 124 | < 0.1% |
| 96 | 129 | < 0.1% |
| Value | Count | Frequency (%) |
| 96 | 129 | < 0.1% |
| 16 | 124 | < 0.1% |
| 15 | 46 | < 0.1% |
| 9 | 256 | < 0.1% |
| 3 | 134 | < 0.1% |
| 2 | 110 | < 0.1% |
| 1 | 45746 |
zero_bal_date
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 169 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 3021495 |
| Missing (%) | 98.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201354.42 |
| Minimum | 200903 |
|---|---|
| Maximum | 202303 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 200903 |
|---|---|
| 5-th percentile | 201008 |
| Q1 | 201111 |
| median | 201212 |
| Q3 | 201507 |
| 95-th percentile | 202011 |
| Maximum | 202303 |
| Range | 1400 |
| Interquartile range (IQR) | 396 |
Descriptive statistics
| Standard deviation | 312.77207 |
|---|---|
| Coefficient of variation (CV) | 0.001553341 |
| Kurtosis | 0.33374613 |
| Mean | 201354.42 |
| Median Absolute Deviation (MAD) | 111 |
| Skewness | 1.0588122 |
| Sum | 9.3720416 × 109 |
| Variance | 97826.369 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 201011 | 1072 | < 0.1% |
| 201210 | 1021 | < 0.1% |
| 201110 | 1014 | < 0.1% |
| 201111 | 1010 | < 0.1% |
| 201203 | 972 | < 0.1% |
| 201208 | 968 | < 0.1% |
| 201010 | 944 | < 0.1% |
| 201202 | 926 | < 0.1% |
| 201112 | 919 | < 0.1% |
| 201209 | 913 | < 0.1% |
| Other values (159) | 36786 | 1.2% |
| (Missing) | 3021495 |
| Value | Count | Frequency (%) |
| 200903 | 4 | < 0.1% |
| 200904 | 17 | < 0.1% |
| 200905 | 37 | < 0.1% |
| 200906 | 48 | < 0.1% |
| 200907 | 42 | < 0.1% |
| 200908 | 43 | < 0.1% |
| 200909 | 48 | < 0.1% |
| 200910 | 100 | |
| 200911 | 150 | |
| 200912 | 181 |
| Value | Count | Frequency (%) |
| 202303 | 42 | |
| 202302 | 14 | < 0.1% |
| 202301 | 39 | |
| 202212 | 38 | |
| 202211 | 40 | |
| 202210 | 42 | |
| 202209 | 57 | |
| 202208 | 54 | |
| 202207 | 45 | |
| 202206 | 45 |
curr_int
Real number (ℝ)
HIGH CORRELATION
| Distinct | 266 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.968149 |
| Minimum | 2 |
|---|---|
| Maximum | 7.875 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4.375 |
| Q1 | 4.75 |
| median | 4.875 |
| Q3 | 5.25 |
| 95-th percentile | 5.625 |
| Maximum | 7.875 |
| Range | 5.875 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.40295387 |
|---|---|
| Coefficient of variation (CV) | 0.081107444 |
| Kurtosis | 1.2530247 |
| Mean | 4.968149 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | 0.65682423 |
| Sum | 15242480 |
| Variance | 0.16237182 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.875 | 573990 | |
| 4.75 | 472422 | |
| 5 | 295921 | |
| 5.25 | 270076 | |
| 5.375 | 213829 | 7.0% |
| 5.125 | 206153 | 6.7% |
| 4.5 | 192918 | 6.3% |
| 4.625 | 181404 | 5.9% |
| 5.5 | 142788 | 4.7% |
| 4.375 | 126423 | 4.1% |
| Other values (256) | 392116 |
| Value | Count | Frequency (%) |
| 2 | 38 | < 0.1% |
| 2.875 | 115 | < 0.1% |
| 3 | 60 | < 0.1% |
| 3.125 | 393 | < 0.1% |
| 3.25 | 71 | < 0.1% |
| 3.5 | 170 | < 0.1% |
| 3.625 | 164 | < 0.1% |
| 3.75 | 687 | < 0.1% |
| 3.875 | 779 | < 0.1% |
| 4 | 5790 |
| Value | Count | Frequency (%) |
| 7.875 | 11 | < 0.1% |
| 7.5 | 39 | < 0.1% |
| 7.375 | 107 | < 0.1% |
| 7.25 | 186 | < 0.1% |
| 7.125 | 254 | < 0.1% |
| 7 | 125 | < 0.1% |
| 6.875 | 767 | < 0.1% |
| 6.75 | 1165 | < 0.1% |
| 6.625 | 2883 | |
| 6.5 | 5559 |
curr_deferred_upb
Real number (ℝ)
SKEWED ZEROS
| Distinct | 256 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.700474 |
| Minimum | 0 |
|---|---|
| Maximum | 146747.84 |
| Zeros | 3061632 |
| Zeros (%) | 99.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 146747.84 |
| Range | 146747.84 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1384.1635 |
|---|---|
| Coefficient of variation (CV) | 34.008535 |
| Kurtosis | 3371.345 |
| Mean | 40.700474 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 51.20668 |
| Sum | 1.2487068 × 108 |
| Variance | 1915908.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 3061632 | |
| 1402.22 | 118 | < 0.1% |
| 13670.22 | 115 | < 0.1% |
| 43076.8 | 110 | < 0.1% |
| 49272.47 | 92 | < 0.1% |
| 31314.81 | 88 | < 0.1% |
| 8731.79 | 86 | < 0.1% |
| 65484.29 | 83 | < 0.1% |
| 15487.65 | 81 | < 0.1% |
| 73056.13 | 78 | < 0.1% |
| Other values (246) | 5557 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 3061632 | |
| 381.03 | 32 | < 0.1% |
| 381.14 | 33 | < 0.1% |
| 508.74 | 15 | < 0.1% |
| 671.51 | 2 | < 0.1% |
| 758.62 | 51 | < 0.1% |
| 807.98 | 5 | < 0.1% |
| 1009.72 | 22 | < 0.1% |
| 1135.24 | 7 | < 0.1% |
| 1143.43 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 146747.84 | 41 | |
| 90012.55 | 47 | |
| 88591.48 | 51 | |
| 75052.94 | 47 | |
| 74881.79 | 1 | < 0.1% |
| 74706.29 | 41 | |
| 73056.13 | 78 | |
| 68615.11 | 34 | |
| 67895.37 | 18 | < 0.1% |
| 65545.51 | 44 |
ddlpi
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 170 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 3062559 |
| Missing (%) | 99.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201921.19 |
| Minimum | 200201 |
|---|---|
| Maximum | 204001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 200201 |
|---|---|
| 5-th percentile | 201109 |
| Q1 | 201908 |
| median | 202008 |
| Q3 | 202106 |
| 95-th percentile | 202208 |
| Maximum | 204001 |
| Range | 3800 |
| Interquartile range (IQR) | 198 |
Descriptive statistics
| Standard deviation | 317.26894 |
|---|---|
| Coefficient of variation (CV) | 0.0015712513 |
| Kurtosis | 2.2587441 |
| Mean | 201921.19 |
| Median Absolute Deviation (MAD) | 99 |
| Skewness | -1.6421073 |
| Sum | 1.10673 × 109 |
| Variance | 100659.58 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 202010 | 169 | < 0.1% |
| 202009 | 154 | < 0.1% |
| 202008 | 154 | < 0.1% |
| 202007 | 151 | < 0.1% |
| 202005 | 148 | < 0.1% |
| 202104 | 145 | < 0.1% |
| 202012 | 140 | < 0.1% |
| 202103 | 137 | < 0.1% |
| 202004 | 136 | < 0.1% |
| 202006 | 130 | < 0.1% |
| Other values (160) | 4017 | 0.1% |
| (Missing) | 3062559 |
| Value | Count | Frequency (%) |
| 200201 | 1 | < 0.1% |
| 200905 | 2 | < 0.1% |
| 200908 | 1 | < 0.1% |
| 200909 | 3 | < 0.1% |
| 200910 | 4 | < 0.1% |
| 200911 | 4 | < 0.1% |
| 200912 | 5 | |
| 201001 | 8 | |
| 201002 | 11 | |
| 201003 | 8 |
| Value | Count | Frequency (%) |
| 204001 | 1 | < 0.1% |
| 202410 | 3 | < 0.1% |
| 202409 | 1 | < 0.1% |
| 202309 | 1 | < 0.1% |
| 202305 | 1 | < 0.1% |
| 202304 | 2 | < 0.1% |
| 202303 | 32 | |
| 202302 | 20 | |
| 202301 | 26 | |
| 202212 | 36 |
mi_rec
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 54 |
|---|---|
| Distinct (%) | 9.9% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4773.8838 |
| Minimum | 0 |
|---|---|
| Maximum | 124594.73 |
| Zeros | 490 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 43423.463 |
| Maximum | 124594.73 |
| Range | 124594.73 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 16244.315 |
|---|---|
| Coefficient of variation (CV) | 3.4027462 |
| Kurtosis | 14.940713 |
| Mean | 4773.8838 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.7790762 |
| Sum | 2592218.9 |
| Variance | 2.6387777 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 490 | < 0.1% |
| 34886.58 | 1 | < 0.1% |
| 7656.48 | 1 | < 0.1% |
| 62002.15 | 1 | < 0.1% |
| 22085.83 | 1 | < 0.1% |
| 11497.93 | 1 | < 0.1% |
| 54866.64 | 1 | < 0.1% |
| 19980.84 | 1 | < 0.1% |
| 51957.76 | 1 | < 0.1% |
| 59512.82 | 1 | < 0.1% |
| Other values (44) | 44 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| 0 | 490 | |
| 7656.48 | 1 | < 0.1% |
| 11497.93 | 1 | < 0.1% |
| 16923.07 | 1 | < 0.1% |
| 19980.84 | 1 | < 0.1% |
| 21152.26 | 1 | < 0.1% |
| 22085.83 | 1 | < 0.1% |
| 26441.24 | 1 | < 0.1% |
| 26972.29 | 1 | < 0.1% |
| 27146.41 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 124594.73 | 1 | |
| 92612.42 | 1 | |
| 87672.45 | 1 | |
| 86316.55 | 1 | |
| 82380.99 | 1 | |
| 78947.86 | 1 | |
| 76640.65 | 1 | |
| 73901.86 | 1 | |
| 70864.64 | 1 | |
| 67875.19 | 1 |
net_sales
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 529 |
|---|---|
| Distinct (%) | 97.1% |
| Missing | 3067495 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 138018.72 |
| Minimum | 0 |
|---|---|
| Maximum | 663087.46 |
| Zeros | 15 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 16140.672 |
| Q1 | 69084.73 |
| median | 124358.03 |
| Q3 | 197069.65 |
| 95-th percentile | 306585.37 |
| Maximum | 663087.46 |
| Range | 663087.46 |
| Interquartile range (IQR) | 127984.92 |
Descriptive statistics
| Standard deviation | 91931.557 |
|---|---|
| Coefficient of variation (CV) | 0.66608034 |
| Kurtosis | 2.3003498 |
| Mean | 138018.72 |
| Median Absolute Deviation (MAD) | 63372.03 |
| Skewness | 1.0463539 |
| Sum | 75220203 |
| Variance | 8.4514111 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 15 | < 0.1% |
| 50000 | 2 | < 0.1% |
| 49000 | 2 | < 0.1% |
| 112382.72 | 1 | < 0.1% |
| 88708.45 | 1 | < 0.1% |
| 160748.08 | 1 | < 0.1% |
| 190374.54 | 1 | < 0.1% |
| 28260.79 | 1 | < 0.1% |
| 280644.52 | 1 | < 0.1% |
| 78770 | 1 | < 0.1% |
| Other values (519) | 519 | < 0.1% |
| (Missing) | 3067495 |
| Value | Count | Frequency (%) |
| 0 | 15 | |
| 876 | 1 | < 0.1% |
| 1597.91 | 1 | < 0.1% |
| 2835.52 | 1 | < 0.1% |
| 6489.18 | 1 | < 0.1% |
| 7100 | 1 | < 0.1% |
| 8139.55 | 1 | < 0.1% |
| 10670.99 | 1 | < 0.1% |
| 10994.87 | 1 | < 0.1% |
| 11250 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 663087.46 | 1 | |
| 581000 | 1 | |
| 462062.7 | 1 | |
| 406654.5 | 1 | |
| 396127.33 | 1 | |
| 359546.52 | 1 | |
| 352104.2 | 1 | |
| 350413.81 | 1 | |
| 350189.9 | 1 | |
| 348847.91 | 1 |
non_mi_rec
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 419 |
|---|---|
| Distinct (%) | 77.2% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2333.905 |
| Minimum | 0 |
|---|---|
| Maximum | 121398.74 |
| Zeros | 123 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 43.405 |
| median | 993.39 |
| Q3 | 2257.305 |
| 95-th percentile | 6557.014 |
| Maximum | 121398.74 |
| Range | 121398.74 |
| Interquartile range (IQR) | 2213.9 |
Descriptive statistics
| Standard deviation | 8081.0571 |
|---|---|
| Coefficient of variation (CV) | 3.4624619 |
| Kurtosis | 142.23645 |
| Mean | 2333.905 |
| Median Absolute Deviation (MAD) | 993.39 |
| Skewness | 11.254543 |
| Sum | 1267310.4 |
| Variance | 65303484 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 123 | < 0.1% |
| 1 | 2 | < 0.1% |
| 0.02 | 2 | < 0.1% |
| 5911.79 | 1 | < 0.1% |
| 625.28 | 1 | < 0.1% |
| 8254.43 | 1 | < 0.1% |
| 645.54 | 1 | < 0.1% |
| 4756.72 | 1 | < 0.1% |
| 1825.84 | 1 | < 0.1% |
| 188.15 | 1 | < 0.1% |
| Other values (409) | 409 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| 0 | 123 | |
| 0.01 | 1 | < 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.11 | 1 | < 0.1% |
| 0.23 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 2.63 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11.85 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 121398.74 | 1 | |
| 93328.82 | 1 | |
| 90290.03 | 1 | |
| 40190.39 | 1 | |
| 26126.28 | 1 | |
| 22043.9 | 1 | |
| 16703.66 | 1 | |
| 13979.09 | 1 | |
| 13896.23 | 1 | |
| 13040.55 | 1 |
expenses
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 511 |
|---|---|
| Distinct (%) | 94.1% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -18020.092 |
| Minimum | -185779.28 |
|---|---|
| Maximum | 0 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Negative | 526 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -185779.28 |
|---|---|
| 5-th percentile | -49140.94 |
| Q1 | -24939.975 |
| median | -12802.72 |
| Q3 | -5404.67 |
| 95-th percentile | -145 |
| Maximum | 0 |
| Range | 185779.28 |
| Interquartile range (IQR) | 19535.305 |
Descriptive statistics
| Standard deviation | 18924.657 |
|---|---|
| Coefficient of variation (CV) | -1.0501976 |
| Kurtosis | 16.596275 |
| Mean | -18020.092 |
| Median Absolute Deviation (MAD) | 8465.82 |
| Skewness | -2.9852566 |
| Sum | -9784910 |
| Variance | 3.5814265 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 17 | < 0.1% |
| -145 | 10 | < 0.1% |
| -110 | 4 | < 0.1% |
| -290 | 3 | < 0.1% |
| -200 | 3 | < 0.1% |
| -8480.18 | 1 | < 0.1% |
| -1728.53 | 1 | < 0.1% |
| -8404.59 | 1 | < 0.1% |
| -15307.64 | 1 | < 0.1% |
| -392.5 | 1 | < 0.1% |
| Other values (501) | 501 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| -185779.28 | 1 | |
| -147344.86 | 1 | |
| -100575.77 | 1 | |
| -97324.12 | 1 | |
| -88731.08 | 1 | |
| -84652.98 | 1 | |
| -81783.07 | 1 | |
| -80113.68 | 1 | |
| -78652.13 | 1 | |
| -74240.26 | 1 |
| Value | Count | Frequency (%) |
| 0 | 17 | |
| -25 | 1 | < 0.1% |
| -85 | 1 | < 0.1% |
| -110 | 4 | < 0.1% |
| -145 | 10 | |
| -149.01 | 1 | < 0.1% |
| -170 | 1 | < 0.1% |
| -171 | 1 | < 0.1% |
| -200 | 3 | < 0.1% |
| -230 | 1 | < 0.1% |
legal_costs
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 460 |
|---|---|
| Distinct (%) | 84.7% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -3445.1848 |
| Minimum | -48144.66 |
|---|---|
| Maximum | 0 |
| Zeros | 79 |
| Zeros (%) | < 0.1% |
| Negative | 464 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -48144.66 |
|---|---|
| 5-th percentile | -8348.03 |
| Q1 | -4481.37 |
| median | -3018.22 |
| Q3 | -1293.855 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 48144.66 |
| Interquartile range (IQR) | 3187.515 |
Descriptive statistics
| Standard deviation | 3499.6451 |
|---|---|
| Coefficient of variation (CV) | -1.0158077 |
| Kurtosis | 50.407235 |
| Mean | -3445.1848 |
| Median Absolute Deviation (MAD) | 1589.16 |
| Skewness | -4.7720353 |
| Sum | -1870735.3 |
| Variance | 12247516 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 79 | < 0.1% |
| -1 | 2 | < 0.1% |
| -2032.73 | 2 | < 0.1% |
| -590 | 2 | < 0.1% |
| -75 | 2 | < 0.1% |
| -282.5 | 2 | < 0.1% |
| -799 | 1 | < 0.1% |
| -3770.42 | 1 | < 0.1% |
| -1435 | 1 | < 0.1% |
| -8174.27 | 1 | < 0.1% |
| Other values (450) | 450 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| -48144.66 | 1 | |
| -18548.03 | 1 | |
| -18546.83 | 1 | |
| -18026.49 | 1 | |
| -17388 | 1 | |
| -14945 | 1 | |
| -13644.3 | 1 | |
| -13478.62 | 1 | |
| -13462.1 | 1 | |
| -12762.5 | 1 |
| Value | Count | Frequency (%) |
| 0 | 79 | |
| -1 | 2 | < 0.1% |
| -15 | 1 | < 0.1% |
| -25 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -68 | 1 | < 0.1% |
| -75 | 2 | < 0.1% |
| -85 | 1 | < 0.1% |
| -87 | 1 | < 0.1% |
| -185 | 1 | < 0.1% |
maint_costs
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 406 |
|---|---|
| Distinct (%) | 74.8% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5999.283 |
| Minimum | -62820.81 |
|---|---|
| Maximum | 0 |
| Zeros | 71 |
| Zeros (%) | < 0.1% |
| Negative | 472 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -62820.81 |
|---|---|
| 5-th percentile | -24325.146 |
| Q1 | -8635.935 |
| median | -1424.25 |
| Q3 | -90 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 62820.81 |
| Interquartile range (IQR) | 8545.935 |
Descriptive statistics
| Standard deviation | 9184.6078 |
|---|---|
| Coefficient of variation (CV) | -1.5309509 |
| Kurtosis | 6.7835948 |
| Mean | -5999.283 |
| Median Absolute Deviation (MAD) | 1424.25 |
| Skewness | -2.2992225 |
| Sum | -3257610.7 |
| Variance | 84357020 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 71 | < 0.1% |
| -80 | 8 | < 0.1% |
| -30 | 6 | < 0.1% |
| -135 | 6 | < 0.1% |
| -75 | 5 | < 0.1% |
| -90 | 5 | < 0.1% |
| -60 | 5 | < 0.1% |
| -105 | 5 | < 0.1% |
| -45 | 4 | < 0.1% |
| -165 | 4 | < 0.1% |
| Other values (396) | 424 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| -62820.81 | 1 | |
| -59058.09 | 1 | |
| -48217.73 | 1 | |
| -42949.9 | 1 | |
| -41948.43 | 1 | |
| -39775.79 | 1 | |
| -39588.02 | 1 | |
| -35688.81 | 1 | |
| -35058.1 | 1 | |
| -34283.24 | 1 |
| Value | Count | Frequency (%) |
| 0 | 71 | |
| -5 | 1 | < 0.1% |
| -10 | 3 | < 0.1% |
| -13 | 1 | < 0.1% |
| -13.5 | 2 | < 0.1% |
| -15 | 1 | < 0.1% |
| -16 | 2 | < 0.1% |
| -20 | 2 | < 0.1% |
| -21.9 | 1 | < 0.1% |
| -26 | 1 | < 0.1% |
tax_ins
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 466 |
|---|---|
| Distinct (%) | 85.8% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -7508.541 |
| Minimum | -168026.28 |
|---|---|
| Maximum | 5260.59 |
| Zeros | 78 |
| Zeros (%) | < 0.1% |
| Negative | 456 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -168026.28 |
|---|---|
| 5-th percentile | -23937.585 |
| Q1 | -9241.195 |
| median | -4236.02 |
| Q3 | -1417.04 |
| 95-th percentile | 0 |
| Maximum | 5260.59 |
| Range | 173286.87 |
| Interquartile range (IQR) | 7824.155 |
Descriptive statistics
| Standard deviation | 12169.4 |
|---|---|
| Coefficient of variation (CV) | -1.620741 |
| Kurtosis | 61.362874 |
| Mean | -7508.541 |
| Median Absolute Deviation (MAD) | 3563.16 |
| Skewness | -6.0378937 |
| Sum | -4077137.8 |
| Variance | 1.480943 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 78 | < 0.1% |
| -75328.58 | 1 | < 0.1% |
| -3793.09 | 1 | < 0.1% |
| -1575.07 | 1 | < 0.1% |
| -17324.05 | 1 | < 0.1% |
| -6319.02 | 1 | < 0.1% |
| -4927.1 | 1 | < 0.1% |
| -114.03 | 1 | < 0.1% |
| -675.43 | 1 | < 0.1% |
| -13581.51 | 1 | < 0.1% |
| Other values (456) | 456 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| -168026.28 | 1 | |
| -76523.85 | 1 | |
| -75328.58 | 1 | |
| -61537.22 | 1 | |
| -60512.15 | 1 | |
| -59207.35 | 1 | |
| -54707.69 | 1 | |
| -50950.68 | 1 | |
| -50197.38 | 1 | |
| -48064.46 | 1 |
| Value | Count | Frequency (%) |
| 5260.59 | 1 | < 0.1% |
| 5044.85 | 1 | < 0.1% |
| 2149.1 | 1 | < 0.1% |
| 1520.26 | 1 | < 0.1% |
| 817.74 | 1 | < 0.1% |
| 448.55 | 1 | < 0.1% |
| 262 | 1 | < 0.1% |
| 139 | 1 | < 0.1% |
| 9.49 | 1 | < 0.1% |
| 0 | 78 |
misc_expenses
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 304 |
|---|---|
| Distinct (%) | 56.0% |
| Missing | 3067497 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1067.0834 |
| Minimum | -12737.33 |
|---|---|
| Maximum | 3727.13 |
| Zeros | 27 |
| Zeros (%) | < 0.1% |
| Negative | 509 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -12737.33 |
|---|---|
| 5-th percentile | -5024.25 |
| Q1 | -1236.665 |
| median | -485 |
| Q3 | -160 |
| 95-th percentile | 0 |
| Maximum | 3727.13 |
| Range | 16464.46 |
| Interquartile range (IQR) | 1076.665 |
Descriptive statistics
| Standard deviation | 1753.9676 |
|---|---|
| Coefficient of variation (CV) | -1.6437025 |
| Kurtosis | 12.46609 |
| Mean | -1067.0834 |
| Median Absolute Deviation (MAD) | 393.98 |
| Skewness | -3.0978085 |
| Sum | -579426.26 |
| Variance | 3076402.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -145 | 57 | < 0.1% |
| -255 | 29 | < 0.1% |
| 0 | 27 | < 0.1% |
| -290 | 22 | < 0.1% |
| -110 | 17 | < 0.1% |
| -85 | 11 | < 0.1% |
| -200 | 9 | < 0.1% |
| -400 | 7 | < 0.1% |
| -151.95 | 7 | < 0.1% |
| -220 | 6 | < 0.1% |
| Other values (294) | 351 | < 0.1% |
| (Missing) | 3067497 |
| Value | Count | Frequency (%) |
| -12737.33 | 1 | |
| -11901.17 | 1 | |
| -10923.75 | 1 | |
| -9170 | 1 | |
| -8930.87 | 1 | |
| -8705 | 1 | |
| -8374.59 | 1 | |
| -8075 | 1 | |
| -8051.42 | 1 | |
| -7447.96 | 1 |
| Value | Count | Frequency (%) |
| 3727.13 | 1 | < 0.1% |
| 2930 | 1 | < 0.1% |
| 2890.57 | 1 | < 0.1% |
| 2039.58 | 1 | < 0.1% |
| 1806.67 | 1 | < 0.1% |
| 1670.09 | 1 | < 0.1% |
| 1054.81 | 1 | < 0.1% |
| 0 | 27 | |
| -30 | 3 | < 0.1% |
| -85 | 11 |
actual_loss
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 529 |
|---|---|
| Distinct (%) | 97.1% |
| Missing | 3067495 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -65237.152 |
| Minimum | -557148.85 |
|---|---|
| Maximum | 52706.85 |
| Zeros | 16 |
| Zeros (%) | < 0.1% |
| Negative | 517 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -557148.85 |
|---|---|
| 5-th percentile | -172997.44 |
| Q1 | -89124.59 |
| median | -52205.88 |
| Q3 | -26639.02 |
| 95-th percentile | -5 |
| Maximum | 52706.85 |
| Range | 609855.7 |
| Interquartile range (IQR) | 62485.57 |
Descriptive statistics
| Standard deviation | 58641.801 |
|---|---|
| Coefficient of variation (CV) | -0.89890191 |
| Kurtosis | 10.344934 |
| Mean | -65237.152 |
| Median Absolute Deviation (MAD) | 29799.35 |
| Skewness | -2.178577 |
| Sum | -35554248 |
| Variance | 3.4388608 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 16 | < 0.1% |
| -110 | 2 | < 0.1% |
| -230555.66 | 1 | < 0.1% |
| -94861.55 | 1 | < 0.1% |
| -5102.5 | 1 | < 0.1% |
| -73678.72 | 1 | < 0.1% |
| -4943.24 | 1 | < 0.1% |
| -23781.58 | 1 | < 0.1% |
| -99080.84 | 1 | < 0.1% |
| -147974.29 | 1 | < 0.1% |
| Other values (519) | 519 | < 0.1% |
| (Missing) | 3067495 |
| Value | Count | Frequency (%) |
| -557148.85 | 1 | |
| -299821.11 | 1 | |
| -298447.32 | 1 | |
| -293023.55 | 1 | |
| -273379.99 | 1 | |
| -272685.82 | 1 | |
| -248882.24 | 1 | |
| -236209.83 | 1 | |
| -235911.92 | 1 | |
| -232226.45 | 1 |
| Value | Count | Frequency (%) |
| 52706.85 | 1 | |
| 52513.75 | 1 | |
| 2161 | 1 | |
| 2022.93 | 1 | |
| 2008.4 | 1 | |
| 1570.94 | 1 | |
| 1339.65 | 1 | |
| 1250.37 | 1 | |
| 632.59 | 1 | |
| 624.72 | 1 |
mod_cost
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 460 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 3067580 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7475.585 |
| Minimum | -8011.44 |
|---|---|
| Maximum | 79408.85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 54 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -8011.44 |
|---|---|
| 5-th percentile | -430.3945 |
| Q1 | 338.1975 |
| median | 1645.415 |
| Q3 | 10016.298 |
| 95-th percentile | 32696.984 |
| Maximum | 79408.85 |
| Range | 87420.29 |
| Interquartile range (IQR) | 9678.1 |
Descriptive statistics
| Standard deviation | 12176.01 |
|---|---|
| Coefficient of variation (CV) | 1.6287701 |
| Kurtosis | 8.7247188 |
| Mean | 7475.585 |
| Median Absolute Deviation (MAD) | 1772.715 |
| Skewness | 2.6365947 |
| Sum | 3438769.1 |
| Variance | 1.4825521 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21252.86 | 1 | < 0.1% |
| 38068.87 | 1 | < 0.1% |
| 11573.13 | 1 | < 0.1% |
| 36174.35 | 1 | < 0.1% |
| 3279.24 | 1 | < 0.1% |
| 21438.27 | 1 | < 0.1% |
| -387.04 | 1 | < 0.1% |
| -52.49 | 1 | < 0.1% |
| 6974.29 | 1 | < 0.1% |
| 39751.22 | 1 | < 0.1% |
| Other values (450) | 450 | < 0.1% |
| (Missing) | 3067580 |
| Value | Count | Frequency (%) |
| -8011.44 | 1 | |
| -4200.31 | 1 | |
| -2484.92 | 1 | |
| -2235.98 | 1 | |
| -2068.46 | 1 | |
| -1548.76 | 1 | |
| -1342.89 | 1 | |
| -1318.23 | 1 | |
| -1168.81 | 1 | |
| -1039.08 | 1 |
| Value | Count | Frequency (%) |
| 79408.85 | 1 | |
| 77071.58 | 1 | |
| 69270.11 | 1 | |
| 67728.15 | 1 | |
| 59049.17 | 1 | |
| 51152.84 | 1 | |
| 49006.37 | 1 | |
| 48822.5 | 1 | |
| 48594.77 | 1 | |
| 47722.3 | 1 |
step_mod
Boolean
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 3067566 |
| Missing (%) | > 99.9% |
| Memory size | 5.9 MiB |
| False | 474 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 474 | < 0.1% |
| (Missing) | 3067566 |
deferred_payment_plan
Categorical
HIGH CORRELATION IMBALANCE MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3063801 |
| Missing (%) | 99.9% |
| Memory size | 23.4 MiB |
| P | |
|---|---|
| Y | 209 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4239 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Y |
|---|---|
| 2nd row | P |
| 3rd row | P |
| 4th row | P |
| 5th row | P |
Common Values
| Value | Count | Frequency (%) |
| P | 4030 | 0.1% |
| Y | 209 | < 0.1% |
| (Missing) | 3063801 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| p | 4030 | |
| y | 209 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 4030 | |
| Y | 209 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4239 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 4030 | |
| Y | 209 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4239 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 4030 | |
| Y | 209 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4239 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 4030 | |
| Y | 209 | 4.9% |
eltv
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 195 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2581932 |
| Missing (%) | 84.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.67751 |
| Minimum | 1 |
|---|---|
| Maximum | 999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 24 |
| median | 40 |
| Q3 | 58 |
| 95-th percentile | 999 |
| Maximum | 999 |
| Range | 998 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 302.17442 |
|---|---|
| Coefficient of variation (CV) | 2.1031435 |
| Kurtosis | 4.1155926 |
| Mean | 143.67751 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 2.4654187 |
| Sum | 69842786 |
| Variance | 91309.378 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 999 | 53759 | 1.8% |
| 32 | 8300 | 0.3% |
| 33 | 8188 | 0.3% |
| 34 | 8135 | 0.3% |
| 38 | 8100 | 0.3% |
| 31 | 8057 | 0.3% |
| 36 | 8033 | 0.3% |
| 35 | 7987 | 0.3% |
| 30 | 7956 | 0.3% |
| 37 | 7904 | 0.3% |
| Other values (185) | 359689 | 11.7% |
| (Missing) | 2581932 |
| Value | Count | Frequency (%) |
| 1 | 1761 | 0.1% |
| 2 | 2289 | |
| 3 | 2804 | |
| 4 | 3562 | |
| 5 | 3972 | |
| 6 | 4277 | |
| 7 | 4536 | |
| 8 | 4635 | |
| 9 | 4728 | |
| 10 | 4765 |
| Value | Count | Frequency (%) |
| 999 | 53759 | |
| 211 | 1 | < 0.1% |
| 207 | 1 | < 0.1% |
| 206 | 1 | < 0.1% |
| 205 | 1 | < 0.1% |
| 203 | 1 | < 0.1% |
| 202 | 3 | < 0.1% |
| 201 | 1 | < 0.1% |
| 200 | 2 | < 0.1% |
| 199 | 1 | < 0.1% |
zero_bal_removal_upb
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 45358 |
|---|---|
| Distinct (%) | 97.4% |
| Missing | 3021495 |
| Missing (%) | 98.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 188165.85 |
| Minimum | 0.01 |
|---|---|
| Maximum | 774925.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 26991.266 |
| Q1 | 101081.99 |
| median | 166741.46 |
| Q3 | 258113.82 |
| 95-th percentile | 397756.74 |
| Maximum | 774925.4 |
| Range | 774925.39 |
| Interquartile range (IQR) | 157031.83 |
Descriptive statistics
| Standard deviation | 117536.71 |
|---|---|
| Coefficient of variation (CV) | 0.62464424 |
| Kurtosis | 0.99667763 |
| Mean | 188165.85 |
| Median Absolute Deviation (MAD) | 74119.63 |
| Skewness | 0.88347681 |
| Sum | 8.7581793 × 109 |
| Variance | 1.3814878 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 415000 | 24 | < 0.1% |
| 414000 | 24 | < 0.1% |
| 416000 | 18 | < 0.1% |
| 409000 | 11 | < 0.1% |
| 100000 | 9 | < 0.1% |
| 115000 | 8 | < 0.1% |
| 399139.31 | 8 | < 0.1% |
| 305000 | 8 | < 0.1% |
| 412000 | 8 | < 0.1% |
| 397166.66 | 8 | < 0.1% |
| Other values (45348) | 46419 | 1.5% |
| (Missing) | 3021495 |
| Value | Count | Frequency (%) |
| 0.01 | 1 | |
| 0.14 | 1 | |
| 1 | 1 | |
| 3.14 | 1 | |
| 3.58 | 1 | |
| 5.18 | 1 | |
| 10.34 | 1 | |
| 11.99 | 1 | |
| 16.8 | 1 | |
| 19.87 | 1 |
| Value | Count | Frequency (%) |
| 774925.4 | 1 | |
| 751728.39 | 1 | |
| 747818.65 | 1 | |
| 746488.3 | 1 | |
| 728000 | 1 | |
| 727000 | 1 | |
| 726000 | 1 | |
| 725000 | 1 | |
| 724000 | 1 | |
| 722950.12 | 1 |
delinq_int
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 575 |
|---|---|
| Distinct (%) | 85.9% |
| Missing | 3067371 |
| Missing (%) | > 99.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12658.866 |
| Minimum | -1142.16 |
|---|---|
| Maximum | 170239.2 |
| Zeros | 95 |
| Zeros (%) | < 0.1% |
| Negative | 5 |
| Negative (%) | < 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -1142.16 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2644.81 |
| median | 7903.53 |
| Q3 | 16605.27 |
| 95-th percentile | 40569.85 |
| Maximum | 170239.2 |
| Range | 171381.36 |
| Interquartile range (IQR) | 13960.46 |
Descriptive statistics
| Standard deviation | 16275.731 |
|---|---|
| Coefficient of variation (CV) | 1.2857179 |
| Kurtosis | 22.565506 |
| Mean | 12658.866 |
| Median Absolute Deviation (MAD) | 6741.33 |
| Skewness | 3.622199 |
| Sum | 8468781.1 |
| Variance | 2.648994 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 95 | < 0.1% |
| 6221.7 | 1 | < 0.1% |
| 3083.33 | 1 | < 0.1% |
| 13372.24 | 1 | < 0.1% |
| 23856.68 | 1 | < 0.1% |
| 13386.54 | 1 | < 0.1% |
| 4628.68 | 1 | < 0.1% |
| 899.69 | 1 | < 0.1% |
| 10339.52 | 1 | < 0.1% |
| 6347.77 | 1 | < 0.1% |
| Other values (565) | 565 | < 0.1% |
| (Missing) | 3067371 |
| Value | Count | Frequency (%) |
| -1142.16 | 1 | < 0.1% |
| -858.52 | 1 | < 0.1% |
| -742.22 | 1 | < 0.1% |
| -223.42 | 1 | < 0.1% |
| -103.04 | 1 | < 0.1% |
| 0 | 95 | |
| 102.11 | 1 | < 0.1% |
| 189.42 | 1 | < 0.1% |
| 222.77 | 1 | < 0.1% |
| 264.35 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 170239.2 | 1 | |
| 142270.57 | 1 | |
| 111369.88 | 1 | |
| 87588.12 | 1 | |
| 79657.68 | 1 | |
| 77541.6 | 1 | |
| 75923.28 | 1 | |
| 74910.77 | 1 | |
| 73377.54 | 1 | |
| 72797.87 | 1 |
delinq_disaster
Boolean
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3064125 |
| Missing (%) | 99.9% |
| Memory size | 5.9 MiB |
| True | 3915 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 3915 | 0.1% |
| (Missing) | 3064125 |
borrower_assistance
Categorical
HIGH CORRELATION MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 3062304 |
| Missing (%) | 99.8% |
| Memory size | 23.4 MiB |
| F | |
|---|---|
| T | |
| R |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5736 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | F |
|---|---|
| 2nd row | F |
| 3rd row | F |
| 4th row | F |
| 5th row | F |
Common Values
| Value | Count | Frequency (%) |
| F | 3672 | 0.1% |
| T | 1514 | < 0.1% |
| R | 550 | < 0.1% |
| (Missing) | 3062304 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| f | 3672 | |
| t | 1514 | |
| r | 550 | 9.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 3672 | |
| T | 1514 | |
| R | 550 | 9.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 5736 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 3672 | |
| T | 1514 | |
| R | 550 | 9.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5736 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 3672 | |
| T | 1514 | |
| R | 550 | 9.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5736 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| F | 3672 | |
| T | 1514 | |
| R | 550 | 9.6% |
curr_month_mod_cost
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 11334 |
|---|---|
| Distinct (%) | 43.4% |
| Missing | 3041908 |
| Missing (%) | 99.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 131.59227 |
| Minimum | -133.11 |
|---|---|
| Maximum | 5128.74 |
| Zeros | 5969 |
| Zeros (%) | 0.2% |
| Negative | 2508 |
| Negative (%) | 0.1% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | -133.11 |
|---|---|
| 5-th percentile | -9.92 |
| Q1 | 0 |
| median | 71.19 |
| Q3 | 191.4725 |
| 95-th percentile | 470.49 |
| Maximum | 5128.74 |
| Range | 5261.85 |
| Interquartile range (IQR) | 191.4725 |
Descriptive statistics
| Standard deviation | 200.81472 |
|---|---|
| Coefficient of variation (CV) | 1.5260374 |
| Kurtosis | 96.11055 |
| Mean | 131.59227 |
| Median Absolute Deviation (MAD) | 71.19 |
| Skewness | 6.1201803 |
| Sum | 3438769.1 |
| Variance | 40326.553 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 5969 | 0.2% |
| 9.84 | 63 | < 0.1% |
| 11.46 | 61 | < 0.1% |
| 2.54 | 51 | < 0.1% |
| 7.9 | 50 | < 0.1% |
| 157.79 | 49 | < 0.1% |
| 206.61 | 48 | < 0.1% |
| 470.49 | 41 | < 0.1% |
| 10.08 | 40 | < 0.1% |
| 352 | 39 | < 0.1% |
| Other values (11324) | 19721 | 0.6% |
| (Missing) | 3041908 |
| Value | Count | Frequency (%) |
| -133.11 | 2 | < 0.1% |
| -118.32 | 1 | < 0.1% |
| -103.53 | 1 | < 0.1% |
| -88.74 | 1 | < 0.1% |
| -83.2 | 1 | < 0.1% |
| -83.15 | 1 | < 0.1% |
| -83.05 | 1 | < 0.1% |
| -82.99 | 7 | |
| -79.89 | 1 | < 0.1% |
| -79.81 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5128.74 | 2 | |
| 4558.88 | 1 | |
| 4519.2 | 2 | |
| 4142.6 | 1 | |
| 3989.02 | 1 | |
| 3766 | 1 | |
| 3419.16 | 1 | |
| 3389.4 | 1 | |
| 3017.52 | 1 | |
| 3012.8 | 1 |
interest_bearing_upb
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 2239895 |
|---|---|
| Distinct (%) | 73.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 169408.94 |
| Minimum | 0 |
|---|---|
| Maximum | 790000 |
| Zeros | 46545 |
| Zeros (%) | 1.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 36137.33 |
| Q1 | 90924.22 |
| median | 146121.67 |
| Q3 | 227811.16 |
| 95-th percentile | 383735.64 |
| Maximum | 790000 |
| Range | 790000 |
| Interquartile range (IQR) | 136886.94 |
Descriptive statistics
| Standard deviation | 107079.89 |
|---|---|
| Coefficient of variation (CV) | 0.63207932 |
| Kurtosis | 1.3503241 |
| Mean | 169408.94 |
| Median Absolute Deviation (MAD) | 63987.135 |
| Skewness | 1.0484879 |
| Sum | 5.197534 × 1011 |
| Variance | 1.1466102 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 46545 | 1.5% |
| 415000 | 3733 | 0.1% |
| 416000 | 3713 | 0.1% |
| 414000 | 3353 | 0.1% |
| 100000 | 2684 | 0.1% |
| 199000 | 2358 | 0.1% |
| 99000 | 2067 | 0.1% |
| 149000 | 2022 | 0.1% |
| 417000 | 1991 | 0.1% |
| 139000 | 1804 | 0.1% |
| Other values (2239885) | 2997770 |
| Value | Count | Frequency (%) |
| 0 | 46545 | |
| 0.01 | 4 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| 3.14 | 1 | < 0.1% |
| 3.58 | 1 | < 0.1% |
| 5.18 | 1 | < 0.1% |
| 10.34 | 1 | < 0.1% |
| 11.99 | 1 | < 0.1% |
| 16.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 790000 | 1 | < 0.1% |
| 789000 | 1 | < 0.1% |
| 788000 | 2 | |
| 787000 | 2 | |
| 786000 | 3 | |
| 785000 | 1 | < 0.1% |
| 784000 | 2 | |
| 783000 | 1 | < 0.1% |
| 782959.35 | 1 | < 0.1% |
| 782000 | 1 | < 0.1% |
| year_month | curr_upb | loan_age | month_remaining_LM | defect_settlement | zero_bal_code | zero_bal_date | curr_int | curr_deferred_upb | ddlpi | mi_rec | net_sales | non_mi_rec | expenses | legal_costs | maint_costs | tax_ins | misc_expenses | actual_loss | mod_cost | eltv | zero_bal_removal_upb | delinq_int | curr_month_mod_cost | interest_bearing_upb | mod_flag | deferred_payment_plan | borrower_assistance | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| year_month | 1.000 | -0.316 | 0.978 | -0.625 | 0.999 | 0.051 | 1.000 | 0.004 | 0.065 | 0.991 | -0.026 | -0.028 | 0.032 | -0.366 | -0.320 | -0.231 | -0.253 | -0.470 | 0.016 | -0.208 | -0.314 | -0.362 | -0.251 | -0.184 | -0.316 | 0.141 | 0.202 | 0.516 |
| curr_upb | -0.316 | 1.000 | -0.315 | 0.412 | NaN | NaN | NaN | -0.029 | 0.005 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -0.091 | 0.388 | NaN | NaN | 0.411 | 1.000 | 0.025 | 0.000 | 0.105 |
| loan_age | 0.978 | -0.315 | 1.000 | -0.641 | 0.862 | 0.006 | 0.972 | -0.009 | -0.033 | 0.899 | -0.019 | -0.115 | -0.012 | -0.324 | -0.284 | -0.237 | -0.220 | -0.360 | 0.004 | 0.464 | -0.330 | -0.362 | 0.205 | 0.098 | -0.315 | 0.209 | 0.152 | 0.470 |
| month_remaining_LM | -0.625 | 0.412 | -0.641 | 1.000 | -0.560 | 0.057 | -0.587 | 0.298 | 0.006 | -0.656 | 0.025 | 0.159 | 0.054 | 0.243 | 0.204 | 0.190 | 0.156 | 0.239 | -0.051 | 0.211 | 0.503 | 0.451 | -0.294 | 0.056 | 0.412 | 0.090 | 0.019 | 0.487 |
| defect_settlement | 0.999 | NaN | 0.862 | -0.560 | 1.000 | -0.319 | 1.000 | -0.079 | NaN | 0.859 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.500 | NaN | 0.132 | NaN | 0.462 | NaN | 1.000 | 0.000 | 0.000 |
| zero_bal_code | 0.051 | NaN | 0.006 | 0.057 | -0.319 | 1.000 | 0.051 | 0.052 | NaN | -0.457 | 0.001 | -0.004 | -0.016 | -0.350 | -0.122 | -0.455 | -0.168 | -0.201 | -0.121 | 0.101 | -0.428 | 0.001 | -0.321 | 0.047 | NaN | 1.000 | 0.000 | 0.000 |
| zero_bal_date | 1.000 | NaN | 0.972 | -0.587 | 1.000 | 0.051 | 1.000 | -0.054 | NaN | 0.991 | -0.026 | -0.028 | 0.032 | -0.366 | -0.320 | -0.231 | -0.253 | -0.470 | 0.016 | -0.101 | -0.134 | -0.362 | -0.251 | -0.078 | NaN | 1.000 | 0.000 | 0.000 |
| curr_int | 0.004 | -0.029 | -0.009 | 0.298 | -0.079 | 0.052 | -0.054 | 1.000 | -0.011 | -0.142 | -0.088 | -0.172 | -0.042 | 0.038 | -0.041 | 0.015 | 0.004 | 0.077 | -0.042 | -0.630 | 0.212 | 0.026 | 0.213 | -0.720 | -0.029 | 0.022 | 0.008 | 0.099 |
| curr_deferred_upb | 0.065 | 0.005 | -0.033 | 0.006 | NaN | NaN | NaN | -0.011 | 1.000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -0.194 | 0.023 | NaN | NaN | 0.162 | -0.002 | 0.000 | 0.065 | 0.032 |
| ddlpi | 0.991 | NaN | 0.899 | -0.656 | 0.859 | -0.457 | 0.991 | -0.142 | NaN | 1.000 | -0.008 | -0.033 | 0.012 | -0.055 | -0.065 | -0.002 | 0.029 | -0.317 | 0.214 | -0.148 | 0.045 | -0.300 | -0.428 | -0.128 | NaN | 1.000 | 0.210 | 0.000 |
| mi_rec | -0.026 | NaN | -0.019 | 0.025 | NaN | 0.001 | -0.026 | -0.088 | NaN | -0.008 | 1.000 | 0.070 | 0.187 | -0.084 | -0.034 | -0.060 | -0.125 | -0.046 | 0.168 | 0.175 | 0.278 | 0.107 | 0.059 | 0.198 | NaN | 1.000 | 1.000 | 0.000 |
| net_sales | -0.028 | NaN | -0.115 | 0.159 | NaN | -0.004 | -0.028 | -0.172 | NaN | -0.033 | 0.070 | 1.000 | 0.270 | -0.207 | -0.069 | 0.030 | -0.332 | 0.007 | -0.170 | 0.366 | 0.235 | 0.834 | 0.578 | 0.239 | NaN | 1.000 | 1.000 | 0.000 |
| non_mi_rec | 0.032 | NaN | -0.012 | 0.054 | NaN | -0.016 | 0.032 | -0.042 | NaN | 0.012 | 0.187 | 0.270 | 1.000 | -0.304 | -0.206 | -0.191 | -0.406 | -0.169 | -0.137 | 0.413 | -0.003 | 0.208 | 0.237 | 0.220 | NaN | 1.000 | 1.000 | 0.000 |
| expenses | -0.366 | NaN | -0.324 | 0.243 | NaN | -0.350 | -0.366 | 0.038 | NaN | -0.055 | -0.084 | -0.207 | -0.304 | 1.000 | 0.731 | 0.794 | 0.799 | 0.507 | 0.463 | -0.523 | -0.198 | -0.124 | -0.659 | -0.400 | NaN | 1.000 | 1.000 | 0.000 |
| legal_costs | -0.320 | NaN | -0.284 | 0.204 | NaN | -0.122 | -0.320 | -0.041 | NaN | -0.065 | -0.034 | -0.069 | -0.206 | 0.731 | 1.000 | 0.534 | 0.570 | 0.320 | 0.392 | -0.380 | -0.025 | -0.017 | -0.500 | -0.325 | NaN | 1.000 | 1.000 | 0.000 |
| maint_costs | -0.231 | NaN | -0.237 | 0.190 | NaN | -0.455 | -0.231 | 0.015 | NaN | -0.002 | -0.060 | 0.030 | -0.191 | 0.794 | 0.534 | 1.000 | 0.439 | 0.485 | 0.326 | -0.410 | -0.181 | 0.101 | -0.410 | -0.335 | NaN | 1.000 | 1.000 | 0.000 |
| tax_ins | -0.253 | NaN | -0.220 | 0.156 | NaN | -0.168 | -0.253 | 0.004 | NaN | 0.029 | -0.125 | -0.332 | -0.406 | 0.799 | 0.570 | 0.439 | 1.000 | 0.240 | 0.455 | -0.591 | -0.177 | -0.288 | -0.691 | -0.355 | NaN | 1.000 | 1.000 | 0.000 |
| misc_expenses | -0.470 | NaN | -0.360 | 0.239 | NaN | -0.201 | -0.470 | 0.077 | NaN | -0.317 | -0.046 | 0.007 | -0.169 | 0.507 | 0.320 | 0.485 | 0.240 | 1.000 | 0.166 | 0.156 | -0.081 | 0.122 | -0.255 | 0.208 | NaN | 1.000 | 1.000 | 0.000 |
| actual_loss | 0.016 | NaN | 0.004 | -0.051 | NaN | -0.121 | 0.016 | -0.042 | NaN | 0.214 | 0.168 | -0.170 | -0.137 | 0.463 | 0.392 | 0.326 | 0.455 | 0.166 | 1.000 | -0.448 | -0.382 | -0.391 | -0.592 | -0.437 | NaN | 1.000 | 1.000 | 0.000 |
| mod_cost | -0.208 | -0.091 | 0.464 | 0.211 | 0.500 | 0.101 | -0.101 | -0.630 | -0.194 | -0.148 | 0.175 | 0.366 | 0.413 | -0.523 | -0.380 | -0.410 | -0.591 | 0.156 | -0.448 | 1.000 | 0.235 | 0.464 | 0.091 | 0.922 | -0.092 | 1.000 | 0.000 | 1.000 |
| eltv | -0.314 | 0.388 | -0.330 | 0.503 | NaN | -0.428 | -0.134 | 0.212 | 0.023 | 0.045 | 0.278 | 0.235 | -0.003 | -0.198 | -0.025 | -0.181 | -0.177 | -0.081 | -0.382 | 0.235 | 1.000 | -0.044 | 0.220 | 0.324 | 0.388 | 0.000 | 0.000 | 0.020 |
| zero_bal_removal_upb | -0.362 | NaN | -0.362 | 0.451 | 0.132 | 0.001 | -0.362 | 0.026 | NaN | -0.300 | 0.107 | 0.834 | 0.208 | -0.124 | -0.017 | 0.101 | -0.288 | 0.122 | -0.391 | 0.464 | -0.044 | 1.000 | 0.356 | 0.401 | NaN | 1.000 | 0.000 | 0.000 |
| delinq_int | -0.251 | NaN | 0.205 | -0.294 | NaN | -0.321 | -0.251 | 0.213 | NaN | -0.428 | 0.059 | 0.578 | 0.237 | -0.659 | -0.500 | -0.410 | -0.691 | -0.255 | -0.592 | 0.091 | 0.220 | 0.356 | 1.000 | 0.206 | NaN | 1.000 | 1.000 | 0.000 |
| curr_month_mod_cost | -0.184 | 0.411 | 0.098 | 0.056 | 0.462 | 0.047 | -0.078 | -0.720 | 0.162 | -0.128 | 0.198 | 0.239 | 0.220 | -0.400 | -0.325 | -0.335 | -0.355 | 0.208 | -0.437 | 0.922 | 0.324 | 0.401 | 0.206 | 1.000 | 0.378 | 0.000 | 0.000 | 0.058 |
| interest_bearing_upb | -0.316 | 1.000 | -0.315 | 0.412 | NaN | NaN | NaN | -0.029 | -0.002 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -0.092 | 0.388 | NaN | NaN | 0.378 | 1.000 | 0.019 | 0.012 | 0.110 |
| mod_flag | 0.141 | 0.025 | 0.209 | 0.090 | 1.000 | 1.000 | 1.000 | 0.022 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.019 | 1.000 | 0.000 | 0.154 |
| deferred_payment_plan | 0.202 | 0.000 | 0.152 | 0.019 | 0.000 | 0.000 | 0.000 | 0.008 | 0.065 | 0.210 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.012 | 0.000 | 1.000 | 0.146 |
| borrower_assistance | 0.516 | 0.105 | 0.470 | 0.487 | 0.000 | 0.000 | 0.000 | 0.099 | 0.032 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.020 | 0.000 | 0.000 | 0.058 | 0.110 | 0.154 | 0.146 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| loan_id | year_month | curr_upb | curr_loan_delinq | loan_age | month_remaining_LM | defect_settlement | mod_flag | zero_bal_code | zero_bal_date | curr_int | curr_deferred_upb | ddlpi | mi_rec | net_sales | non_mi_rec | expenses | legal_costs | maint_costs | tax_ins | misc_expenses | actual_loss | mod_cost | step_mod | deferred_payment_plan | eltv | zero_bal_removal_upb | delinq_int | delinq_disaster | borrower_assistance | curr_month_mod_cost | interest_bearing_upb | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | F09Q10000013 | 200902 | 157000.00 | 0 | 0 | 180 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 157000.00 |
| 1 | F09Q10000013 | 200903 | 156000.00 | 0 | 1 | 179 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 156000.00 |
| 2 | F09Q10000013 | 200904 | 155000.00 | 0 | 2 | 178 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 155000.00 |
| 3 | F09Q10000013 | 200905 | 155000.00 | 0 | 3 | 177 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 155000.00 |
| 4 | F09Q10000013 | 200906 | 154000.00 | 0 | 4 | 176 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 154000.00 |
| 5 | F09Q10000013 | 200907 | 153000.00 | 0 | 5 | 175 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 153000.00 |
| 6 | F09Q10000013 | 200908 | 152000.00 | 0 | 6 | 174 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 152000.00 |
| 7 | F09Q10000013 | 200909 | 151743.42 | 0 | 7 | 173 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 151743.42 |
| 8 | F09Q10000013 | 200910 | 151042.83 | 0 | 8 | 172 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 151042.83 |
| 9 | F09Q10000013 | 200911 | 150339.61 | 0 | 9 | 171 | NaN | NaN | NaN | NaN | 4.5 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 150339.61 |
| loan_id | year_month | curr_upb | curr_loan_delinq | loan_age | month_remaining_LM | defect_settlement | mod_flag | zero_bal_code | zero_bal_date | curr_int | curr_deferred_upb | ddlpi | mi_rec | net_sales | non_mi_rec | expenses | legal_costs | maint_costs | tax_ins | misc_expenses | actual_loss | mod_cost | step_mod | deferred_payment_plan | eltv | zero_bal_removal_upb | delinq_int | delinq_disaster | borrower_assistance | curr_month_mod_cost | interest_bearing_upb | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3068030 | F09Q40451949 | 202206 | 23813.90 | 0 | 149 | 211 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25.0 | NaN | NaN | NaN | NaN | NaN | 23813.90 |
| 3068031 | F09Q40451949 | 202207 | 23813.90 | 0 | 150 | 210 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 21.0 | NaN | NaN | NaN | NaN | NaN | 23813.90 |
| 3068032 | F09Q40451949 | 202208 | 23399.97 | 0 | 151 | 209 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 20.0 | NaN | NaN | NaN | NaN | NaN | 23399.97 |
| 3068033 | F09Q40451949 | 202209 | 22567.06 | 0 | 152 | 208 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 22.0 | NaN | NaN | NaN | NaN | NaN | 22567.06 |
| 3068034 | F09Q40451949 | 202210 | 22567.06 | 0 | 153 | 207 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 23.0 | NaN | NaN | NaN | NaN | NaN | 22567.06 |
| 3068035 | F09Q40451949 | 202211 | 22148.07 | 0 | 154 | 206 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 21.0 | NaN | NaN | NaN | NaN | NaN | 22148.07 |
| 3068036 | F09Q40451949 | 202212 | 21315.02 | 0 | 155 | 205 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 21.0 | NaN | NaN | NaN | NaN | NaN | 21315.02 |
| 3068037 | F09Q40451949 | 202301 | 20874.78 | 0 | 156 | 204 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 23.0 | NaN | NaN | NaN | NaN | NaN | 20874.78 |
| 3068038 | F09Q40451949 | 202302 | 20874.78 | 0 | 157 | 203 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 23.0 | NaN | NaN | NaN | NaN | NaN | 20874.78 |
| 3068039 | F09Q40451949 | 202303 | 19968.89 | 0 | 158 | 202 | NaN | NaN | NaN | NaN | 4.875 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 999.0 | NaN | NaN | NaN | NaN | NaN | 19968.89 |